package tx.bj12320.dao;

import java.util.*;

import javacommon.base.*;
import javacommon.util.*;

import cn.org.rapid_framework.util.*;
import cn.org.rapid_framework.web.util.*;
import cn.org.rapid_framework.page.*;
import cn.org.rapid_framework.page.impl.*;

import tx.bj12320.model.*;
import tx.bj12320.dao.*;
import tx.bj12320.service.*;
import tx.bj12320.vo.query.*;


import static cn.org.rapid_framework.util.ObjectUtils.*;
import org.springframework.stereotype.Repository;

@Repository
public class TszbProcessInfoDao extends BaseHibernateDao<TszbProcessInfo,Long>{

	public Class getEntityClass() {
		return TszbProcessInfo.class;
	}

	public Page findPage(TszbProcessInfoQuery query) {
        // [column]为字符串拼接, {column}为使用占位符. [column]为使用字符串拼接,如username='[username]',偷懒时可以使用字符串拼接
        // [column] 为PageRequest的属性
		String sql = "select t from TszbProcessInfo t where 1=1 "
			  	+ "/~ and t.orgInfoId = {orgInfoId} ~/"
			  	+ "/~ and t.orgInfo.orgName like '%[orgName]%'   ~/"
			  	+ "/~ and t.workOrderType = {workOrderType} ~/"
			  	+ "/~ and t.callerName like '%[callerName]%'   ~/"
			  	+ "/~ and t.callerNumber like '%[callerNumber]%'   ~/"
			  	+ "/~ and t.age = {age} ~/"
			  	+ "/~ and t.sex = {sex} ~/"
			  	+ "/~ and t.eduDegreee = {eduDegreee} ~/"
			  	+ "/~ and t.cellPhone = {cellPhone} ~/"
			  	+ "/~ and t.area = {area} ~/"
			  	+ "/~ and t.occupation = {occupation} ~/"
			  	+ "/~ and t.contaceAddress = {contaceAddress} ~/"
			  	+ "/~ and t.phone = {phone} ~/"
			  	+ "/~ and t.relaUnitName = {relaUnitName} ~/"
			  	+ "/~ and t.relaUnitCode = {relaUnitCode} ~/"
			  	+ "/~ and t.relaPerson = {relaPerson} ~/"
			  	+ "/~ and t.liaisonMan = {liaisonMan} ~/"
			  	+ "/~ and t.liaisonCellPhone = {liaisonCellPhone} ~/"
			  	+ "/~ and t.happenAddress = {happenAddress} ~/"
			  	+ "/~ and t.unitType = {unitType} ~/"
			  	+ "/~ and t.unitTypeDdValue = {unitTypeDdValue} ~/"
			  	+ "/~ and t.department = {department} ~/"
			  	+ "/~ and t.liaisonPhone = {liaisonPhone} ~/"
				+ "/~ and t.happenTime >= {happenTimeBegin} ~/"
				+ "/~ and t.happenTime <= {happenTimeEnd} ~/"
			  	+ "/~ and t.ponderance = {ponderance} ~/"
			  	+ "/~ and t.ponderanceDdValue = {ponderanceDdValue} ~/"
			  	+ "/~ and t.workOrderSource = {workOrderSource} ~/"
			  	+ "/~ and t.workOrderSourceDdValue = {workOrderSourceDdValue} ~/"
			  	+ "/~ and t.zoneName = {zoneName} ~/"
			  	+ "/~ and t.zoneDdValue = {zoneDdValue} ~/"
			  	+ "/~ and t.incomingCallContent like '%[incomingCallContent]%'   ~/"
			  	+ "/~ and t.isBeWorkOrder = {isBeWorkOrder} ~/"
			  	+ "/~ and t.timeLimit = {timeLimit} ~/"
			  	+ "/~ and t.shoulliPerson = {shoulliPerson} ~/"
				+ "/~ and t.shouliTime >= {shouliTimeBegin} ~/"
				+ "/~ and t.shouliTime <= {shouliTimeEnd} ~/"
			  	+ "/~ and t.chushenPerson = {chushenPerson} ~/"
			  	+ "/~ and t.shenhePerson = {shenhePerson} ~/"
			  	+ "/~ and t.receiveDepartment = {receiveDepartment} ~/"
			  	+ "/~ and t.receivePerson = {receivePerson} ~/"
				+ "/~ and t.receiveTime >= {receiveTimeBegin} ~/"
				+ "/~ and t.receiveTime <= {receiveTimeEnd} ~/"
			  	+ "/~ and t.leaderToshowContent = {leaderToshowContent} ~/"
			  	+ "/~ and t.leaderToshowSign = {leaderToshowSign} ~/"
				+ "/~ and t.leaderToshowTime >= {leaderToshowTimeBegin} ~/"
				+ "/~ and t.leaderToshowTime <= {leaderToshowTimeEnd} ~/"
			  	+ "/~ and t.dealDepartment = {dealDepartment} ~/"
			  	+ "/~ and t.dealPerson = {dealPerson} ~/"
				+ "/~ and t.dealTime >= {dealTimeBegin} ~/"
				+ "/~ and t.dealTime <= {dealTimeEnd} ~/"
				+ "/~ and t.feedbackRelaPersonTime >= {feedbackRelaPersonTimeBegin} ~/"
				+ "/~ and t.feedbackRelaPersonTime <= {feedbackRelaPersonTimeEnd} ~/"
			  	+ "/~ and t.dealResult = {dealResult} ~/"
			  	+ "/~ and t.relaPersonIdea = {relaPersonIdea} ~/"
			  	+ "/~ and t.thsiIsTrue = {thsiIsTrue} ~/"
			  	+ "/~ and t.isImprove = {isImprove} ~/"
			  	+ "/~ and t.isImproveText = {isImproveText} ~/"
			  	+ "/~ and t.leaderIssue = {leaderIssue} ~/"
			  	+ "/~ and t.leaderIssueSign = {leaderIssueSign} ~/"
				+ "/~ and t.leaderIssueTime >= {leaderIssueTimeBegin} ~/"
				+ "/~ and t.leaderIssueTime <= {leaderIssueTimeEnd} ~/"
			  	+ "/~ and t.isTrue = {isTrue} ~/"
			  	+ "/~ and t.workOrderSort = {workOrderSort} ~/"
			  	+ "/~ and t.workOrderSortDdValue = {workOrderSortDdValue} ~/"
			  	+ "/~ and t.resolveWay = {resolveWay} ~/"
			  	+ "/~ and t.eventName = {eventName} ~/"
			  	+ "/~ and t.eventHappenArea = {eventHappenArea} ~/"
			  	+ "/~ and t.detailAddress = {detailAddress} ~/"
			  	+ "/~ and t.affectPersonCount = {affectPersonCount} ~/"
			  	+ "/~ and t.invasionPersonCount = {invasionPersonCount} ~/"
			  	+ "/~ and t.deathPersonCount = {deathPersonCount} ~/"
			  	+ "/~ and t.procInstId = {procInstId} ~/"
			  	+ "/~ and t.currActName = {currActName} ~/"
				+ "/~ and t.procStartTime >= {procStartTimeBegin} ~/"
				+ "/~ and t.procStartTime <= {procStartTimeEnd} ~/"
			  	+ "/~ and t.isProcEnd = {isProcEnd} ~/"
				+ "/~ and t.procEndTime >= {procEndTimeBegin} ~/"
				+ "/~ and t.procEndTime <= {procEndTimeEnd} ~/"
			  	+ "/~ and t.currSysUserType = {currSysUserType} ~/"
			  	+ "/~ and t.isReject = {isReject} ~/"
				+ "/~ and t.rejectTime >= {rejectTimeBegin} ~/"
				+ "/~ and t.rejectTime <= {rejectTimeEnd} ~/"
			  	+ "/~ and t.chengbanOrgInfoId = {chengbanOrgInfoId} ~/"
				+ "/~ and t.bzcsScore = {bzcsScore} ~/"
			  	+ "/~ and t.xtdbshScore = {xtdbshScore} ~/"
			  	+ "/~ and t.rejectReason = {rejectReason} ~/"
			  	+ "/~ and t.isSecret = {isSecret} ~/"
				+ "/~ and t.workOrderIssueTime >= {workOrderIssueTimeBegin} ~/"
				+ "/~ and t.workOrderIssueTime <= {workOrderIssueTimeEnd} ~/"
				+ "/~ and t.workOrderDealTime >= {workOrderDealTimeBegin} ~/"
				+ "/~ and t.workOrderDealTime <= {workOrderDealTimeEnd} ~/"
			  	+ "/~ and t.delayState = {delayState} ~/"
			  	+ "/~ and t.delayReason = {delayReason} ~/"
			  	+ "/~ and t.delayDays = {delayDays} ~/"
			  	+ "/~ and t.workOrderDefine = {workOrderDefine} ~/"
			  	+ "/~ and t.workOrderDefineDdValue = {workOrderDefineDdValue} ~/"
			  	+ "/~ and t.attaName = {attaName} ~/"
			  	+ "/~ and t.attaFileName = {attaFileName} ~/"
				+ "/~ order by [sortColumns] ~/";


		return pageQuery(sql,query);
	}

	public Page findPageWithUnReceive(TszbProcessInfoQuery query) {
        // [column]为字符串拼接, {column}为使用占位符. [column]为使用字符串拼接,如username='[username]',偷懒时可以使用字符串拼接
        // [column] 为PageRequest的属性
		String sql = "select t from TszbProcessInfo t where 1=1 "
			  	+ "/~ and t.orgInfoId = {orgInfoId} ~/"
			  	+ "/~ and t.orgInfo.orgName like '%[orgName]%'   ~/"
			  	+ "/~ and t.workOrderType = {workOrderType} ~/"
			  	+ "/~ and t.callerName like '%[callerName]%'   ~/"
			  	+ "/~ and t.callerNumber like '%[callerNumber]%'   ~/"
			  	+ "/~ and t.age = {age} ~/"
			  	+ "/~ and t.sex = {sex} ~/"
			  	+ "/~ and t.eduDegreee = {eduDegreee} ~/"
			  	+ "/~ and t.cellPhone = {cellPhone} ~/"
			  	+ "/~ and t.area = {area} ~/"
			  	+ "/~ and t.occupation = {occupation} ~/"
			  	+ "/~ and t.contaceAddress = {contaceAddress} ~/"
			  	+ "/~ and t.phone = {phone} ~/"
			  	+ "/~ and t.relaUnitName = {relaUnitName} ~/"
			  	+ "/~ and t.relaUnitCode = {relaUnitCode} ~/"
			  	+ "/~ and t.relaPerson = {relaPerson} ~/"
			  	+ "/~ and t.liaisonMan = {liaisonMan} ~/"
			  	+ "/~ and t.liaisonCellPhone = {liaisonCellPhone} ~/"
			  	+ "/~ and t.happenAddress = {happenAddress} ~/"
			  	+ "/~ and t.unitType = {unitType} ~/"
			  	+ "/~ and t.unitTypeDdValue = {unitTypeDdValue} ~/"
			  	+ "/~ and t.department = {department} ~/"
			  	+ "/~ and t.liaisonPhone = {liaisonPhone} ~/"
				+ "/~ and t.happenTime >= {happenTimeBegin} ~/"
				+ "/~ and t.happenTime <= {happenTimeEnd} ~/"
			  	+ "/~ and t.ponderance = {ponderance} ~/"
			  	+ "/~ and t.ponderanceDdValue = {ponderanceDdValue} ~/"
			  	+ "/~ and t.workOrderSource = {workOrderSource} ~/"
			  	+ "/~ and t.workOrderSourceDdValue = {workOrderSourceDdValue} ~/"
			  	+ "/~ and t.zoneName = {zoneName} ~/"
			  	+ "/~ and t.zoneDdValue = {zoneDdValue} ~/"
			  	+ "/~ and t.incomingCallContent = {incomingCallContent} ~/"
			  	+ "/~ and t.isBeWorkOrder = {isBeWorkOrder} ~/"
			  	+ "/~ and t.timeLimit = {timeLimit} ~/"
			  	+ "/~ and t.shoulliPerson = {shoulliPerson} ~/"
				+ "/~ and t.shouliTime >= {shouliTimeBegin} ~/"
				+ "/~ and t.shouliTime <= {shouliTimeEnd} ~/"
			  	+ "/~ and t.chushenPerson = {chushenPerson} ~/"
			  	+ "/~ and t.shenhePerson = {shenhePerson} ~/"
			  	+ "/~ and t.receiveDepartment = {receiveDepartment} ~/"
			  	+ "/~ and t.receivePerson = {receivePerson} ~/"
				+ " and t.receiveTime is null "
			  	+ "/~ and t.leaderToshowContent = {leaderToshowContent} ~/"
			  	+ "/~ and t.leaderToshowSign = {leaderToshowSign} ~/"
				+ "/~ and t.leaderToshowTime >= {leaderToshowTimeBegin} ~/"
				+ "/~ and t.leaderToshowTime <= {leaderToshowTimeEnd} ~/"
			  	+ "/~ and t.dealDepartment = {dealDepartment} ~/"
			  	+ "/~ and t.dealPerson = {dealPerson} ~/"
				+ "/~ and t.dealTime >= {dealTimeBegin} ~/"
				+ "/~ and t.dealTime <= {dealTimeEnd} ~/"
				+ "/~ and t.feedbackRelaPersonTime >= {feedbackRelaPersonTimeBegin} ~/"
				+ "/~ and t.feedbackRelaPersonTime <= {feedbackRelaPersonTimeEnd} ~/"
			  	+ "/~ and t.dealResult = {dealResult} ~/"
			  	+ "/~ and t.relaPersonIdea = {relaPersonIdea} ~/"
			  	+ "/~ and t.thsiIsTrue = {thsiIsTrue} ~/"
			  	+ "/~ and t.isImprove = {isImprove} ~/"
			  	+ "/~ and t.isImproveText = {isImproveText} ~/"
			  	+ "/~ and t.leaderIssue = {leaderIssue} ~/"
			  	+ "/~ and t.leaderIssueSign = {leaderIssueSign} ~/"
				+ "/~ and t.leaderIssueTime >= {leaderIssueTimeBegin} ~/"
				+ "/~ and t.leaderIssueTime <= {leaderIssueTimeEnd} ~/"
			  	+ "/~ and t.isTrue = {isTrue} ~/"
			  	+ "/~ and t.workOrderSort = {workOrderSort} ~/"
			  	+ "/~ and t.workOrderSortDdValue = {workOrderSortDdValue} ~/"
			  	+ "/~ and t.resolveWay = {resolveWay} ~/"
			  	+ "/~ and t.eventName = {eventName} ~/"
			  	+ "/~ and t.eventHappenArea = {eventHappenArea} ~/"
			  	+ "/~ and t.detailAddress = {detailAddress} ~/"
			  	+ "/~ and t.affectPersonCount = {affectPersonCount} ~/"
			  	+ "/~ and t.invasionPersonCount = {invasionPersonCount} ~/"
			  	+ "/~ and t.deathPersonCount = {deathPersonCount} ~/"
			  	+ "/~ and t.procInstId = {procInstId} ~/"
			  	+ "/~ and t.currActName = {currActName} ~/"
				+ "/~ and t.procStartTime >= {procStartTimeBegin} ~/"
				+ "/~ and t.procStartTime <= {procStartTimeEnd} ~/"
			  	+ "/~ and t.isProcEnd = {isProcEnd} ~/"
				+ "/~ and t.procEndTime >= {procEndTimeBegin} ~/"
				+ "/~ and t.procEndTime <= {procEndTimeEnd} ~/"
			  	+ "/~ and t.currSysUserType = {currSysUserType} ~/"
			  	+ "/~ and t.isReject = {isReject} ~/"
				+ "/~ and t.rejectTime >= {rejectTimeBegin} ~/"
				+ "/~ and t.rejectTime <= {rejectTimeEnd} ~/"
			  	+ "/~ and t.chengbanOrgInfoId = {chengbanOrgInfoId} ~/"
				+ "/~ and t.bzcsScore = {bzcsScore} ~/"
			  	+ "/~ and t.xtdbshScore = {xtdbshScore} ~/"
			  	+ "/~ and t.rejectReason = {rejectReason} ~/"
			  	+ "/~ and t.isSecret = {isSecret} ~/"
			  	+ " and t.workOrderIssueTime is not null "
				+ "/~ and t.workOrderIssueTime >= {workOrderIssueTimeBegin} ~/"
				+ "/~ and t.workOrderIssueTime <= {workOrderIssueTimeEnd} ~/"
				+ "/~ and t.workOrderDealTime >= {workOrderDealTimeBegin} ~/"
				+ "/~ and t.workOrderDealTime <= {workOrderDealTimeEnd} ~/"
			  	+ "/~ and t.delayState = {delayState} ~/"
			  	+ "/~ and t.delayReason = {delayReason} ~/"
			  	+ "/~ and t.delayDays = {delayDays} ~/"
			  	+ "/~ and t.workOrderDefine = {workOrderDefine} ~/"
			  	+ "/~ and t.workOrderDefineDdValue = {workOrderDefineDdValue} ~/"
			  	+ "/~ and t.attaName = {attaName} ~/"
			  	+ "/~ and t.attaFileName = {attaFileName} ~/"
				+ "/~ order by [sortColumns] ~/";


		return pageQuery(sql,query);
	}

	public Page findPageWithUnDeal(TszbProcessInfoQuery query) {
        // [column]为字符串拼接, {column}为使用占位符. [column]为使用字符串拼接,如username='[username]',偷懒时可以使用字符串拼接
        // [column] 为PageRequest的属性
		String sql = "select t from TszbProcessInfo t where 1=1 "
			  	+ "/~ and t.orgInfoId = {orgInfoId} ~/"
			  	+ "/~ and t.orgInfo.orgName like '%[orgName]%'   ~/"
			  	+ "/~ and t.workOrderType = {workOrderType} ~/"
			  	+ "/~ and t.callerName like '%[callerName]%'   ~/"
			  	+ "/~ and t.callerNumber like '%[callerNumber]%'   ~/"
			  	+ "/~ and t.age = {age} ~/"
			  	+ "/~ and t.sex = {sex} ~/"
			  	+ "/~ and t.eduDegreee = {eduDegreee} ~/"
			  	+ "/~ and t.cellPhone = {cellPhone} ~/"
			  	+ "/~ and t.area = {area} ~/"
			  	+ "/~ and t.occupation = {occupation} ~/"
			  	+ "/~ and t.contaceAddress = {contaceAddress} ~/"
			  	+ "/~ and t.phone = {phone} ~/"
			  	+ "/~ and t.relaUnitName = {relaUnitName} ~/"
			  	+ "/~ and t.relaUnitCode = {relaUnitCode} ~/"
			  	+ "/~ and t.relaPerson = {relaPerson} ~/"
			  	+ "/~ and t.liaisonMan = {liaisonMan} ~/"
			  	+ "/~ and t.liaisonCellPhone = {liaisonCellPhone} ~/"
			  	+ "/~ and t.happenAddress = {happenAddress} ~/"
			  	+ "/~ and t.unitType = {unitType} ~/"
			  	+ "/~ and t.unitTypeDdValue = {unitTypeDdValue} ~/"
			  	+ "/~ and t.department = {department} ~/"
			  	+ "/~ and t.liaisonPhone = {liaisonPhone} ~/"
				+ "/~ and t.happenTime >= {happenTimeBegin} ~/"
				+ "/~ and t.happenTime <= {happenTimeEnd} ~/"
			  	+ "/~ and t.ponderance = {ponderance} ~/"
			  	+ "/~ and t.ponderanceDdValue = {ponderanceDdValue} ~/"
			  	+ "/~ and t.workOrderSource = {workOrderSource} ~/"
			  	+ "/~ and t.workOrderSourceDdValue = {workOrderSourceDdValue} ~/"
			  	+ "/~ and t.zoneName = {zoneName} ~/"
			  	+ "/~ and t.zoneDdValue = {zoneDdValue} ~/"
			  	+ "/~ and t.incomingCallContent = {incomingCallContent} ~/"
			  	+ "/~ and t.isBeWorkOrder = {isBeWorkOrder} ~/"
			  	+ " and t.timeLimit is not null "
			  	+ "/~ and t.shoulliPerson = {shoulliPerson} ~/"
				+ "/~ and t.shouliTime >= {shouliTimeBegin} ~/"
				+ "/~ and t.shouliTime <= {shouliTimeEnd} ~/"
			  	+ "/~ and t.chushenPerson = {chushenPerson} ~/"
			  	+ "/~ and t.shenhePerson = {shenhePerson} ~/"
			  	+ "/~ and t.receiveDepartment = {receiveDepartment} ~/"
			  	+ "/~ and t.receivePerson = {receivePerson} ~/"
				+ "/~ and t.receiveTime >= {receiveTimeBegin} ~/"
				+ "/~ and t.receiveTime <= {receiveTimeEnd} ~/"
			  	+ "/~ and t.leaderToshowContent = {leaderToshowContent} ~/"
			  	+ "/~ and t.leaderToshowSign = {leaderToshowSign} ~/"
				+ "/~ and t.leaderToshowTime >= {leaderToshowTimeBegin} ~/"
				+ "/~ and t.leaderToshowTime <= {leaderToshowTimeEnd} ~/"
			  	+ "/~ and t.dealDepartment = {dealDepartment} ~/"
			  	+ "/~ and t.dealPerson = {dealPerson} ~/"
				+ "/~ and t.dealTime >= {dealTimeBegin} ~/"
				+ "/~ and t.dealTime <= {dealTimeEnd} ~/"
				+ "/~ and t.feedbackRelaPersonTime >= {feedbackRelaPersonTimeBegin} ~/"
				+ "/~ and t.feedbackRelaPersonTime <= {feedbackRelaPersonTimeEnd} ~/"
			  	+ "/~ and t.dealResult = {dealResult} ~/"
			  	+ "/~ and t.relaPersonIdea = {relaPersonIdea} ~/"
			  	+ "/~ and t.thsiIsTrue = {thsiIsTrue} ~/"
			  	+ "/~ and t.isImprove = {isImprove} ~/"
			  	+ "/~ and t.isImproveText = {isImproveText} ~/"
			  	+ "/~ and t.leaderIssue = {leaderIssue} ~/"
			  	+ "/~ and t.leaderIssueSign = {leaderIssueSign} ~/"
				+ "/~ and t.leaderIssueTime >= {leaderIssueTimeBegin} ~/"
				+ "/~ and t.leaderIssueTime <= {leaderIssueTimeEnd} ~/"
			  	+ "/~ and t.isTrue = {isTrue} ~/"
			  	+ "/~ and t.workOrderSort = {workOrderSort} ~/"
			  	+ "/~ and t.workOrderSortDdValue = {workOrderSortDdValue} ~/"
			  	+ "/~ and t.resolveWay = {resolveWay} ~/"
			  	+ "/~ and t.eventName = {eventName} ~/"
			  	+ "/~ and t.eventHappenArea = {eventHappenArea} ~/"
			  	+ "/~ and t.detailAddress = {detailAddress} ~/"
			  	+ "/~ and t.affectPersonCount = {affectPersonCount} ~/"
			  	+ "/~ and t.invasionPersonCount = {invasionPersonCount} ~/"
			  	+ "/~ and t.deathPersonCount = {deathPersonCount} ~/"
			  	+ "/~ and t.procInstId = {procInstId} ~/"
			  	+ "/~ and t.currActName = {currActName} ~/"
				+ "/~ and t.procStartTime >= {procStartTimeBegin} ~/"
				+ "/~ and t.procStartTime <= {procStartTimeEnd} ~/"
			  	+ "/~ and t.isProcEnd = {isProcEnd} ~/"
				+ "/~ and t.procEndTime >= {procEndTimeBegin} ~/"
				+ "/~ and t.procEndTime <= {procEndTimeEnd} ~/"
			  	+ "/~ and t.currSysUserType = {currSysUserType} ~/"
			  	+ "/~ and t.isReject = {isReject} ~/"
				+ "/~ and t.rejectTime >= {rejectTimeBegin} ~/"
				+ "/~ and t.rejectTime <= {rejectTimeEnd} ~/"
			  	+ "/~ and t.chengbanOrgInfoId = {chengbanOrgInfoId} ~/"
				+ "/~ and t.bzcsScore = {bzcsScore} ~/"
			  	+ "/~ and t.xtdbshScore = {xtdbshScore} ~/"
			  	+ "/~ and t.rejectReason = {rejectReason} ~/"
			  	+ "/~ and t.isSecret = {isSecret} ~/"
				+ "/~ and t.workOrderIssueTime >= {workOrderIssueTimeBegin} ~/"
				+ "/~ and t.workOrderIssueTime <= {workOrderIssueTimeEnd} ~/"
				+ " and t.workOrderIssueTime is not null "
				+ " and t.workOrderDealTime is null "
			  	+ "/~ and t.delayState = {delayState} ~/"
			  	+ "/~ and t.delayReason = {delayReason} ~/"
			  	+ "/~ and t.delayDays = {delayDays} ~/"
			  	+ "/~ and t.workOrderDefine = {workOrderDefine} ~/"
			  	+ "/~ and t.workOrderDefineDdValue = {workOrderDefineDdValue} ~/"
			  	+ "/~ and t.attaName = {attaName} ~/"
			  	+ "/~ and t.attaFileName = {attaFileName} ~/"
				+ "/~ order by [sortColumns] ~/";


		return pageQuery(sql,query);
	}


}
